﻿{
  "Queries": {

    "Query": [
      {
        "Name": "MsNavSalesByCustomer",
        "QueryPath": "SqlStatement\\MsNavSalesByCustomer.sql",
        "RefreshInterval": 30,
        "DatabaseConnectionString": "Data Source=localhost;Initial Catalog=Demo Database NAV (9-0);Integrated Security=True;User ID=;Password=;Connect Timeout=15;Encrypt=False;TrustServerCertificate=False",
        "ConnectTo": "EventHub",
        "EventHub": {
          "ConnectionString": "Endpoint=sb://[SAMPLE_NS].servicebus.windows.net/;SharedAccessKeyName=[ACCESS_POLICY];SharedAccessKey=[SHARED_KEY];TransportType=Amqp",
          "QueueName": "[QUEUE_NAME]"
        },
        "PowerBiApi": {
          "ClearRecordset": false,
          "UserName": "",
          "Password": "",
          "ClientId": "",
          "DatasetId": "",
          "TableName": ""
        }
      },
      {
        "Name": "RealTimeSample",
        "QueryPath": "SqlStatement\\RealTimeSample.sql",
        "RefreshInterval": 5,
        "DatabaseConnectionString": "Data Source=localhost;Initial Catalog=Demo Database NAV (9-0);Integrated Security=True;User ID=;Password=;Connect Timeout=15;Encrypt=False;TrustServerCertificate=False",
        "ConnectTo": "PowerBiApi",
        "EventHub": {
          "ConnectionString": "",
          "QueueName": ""
        },
        "PowerBiApi": {
          "ClearRecordset": false,
          "UserName": "[USER_NAME]@[YOUR_DOMAIN].onmicrosoft.com",
          "Password": "[PASSWORD]",
          "ClientId": "[CLIENT_ID_KEY_GUID]",
          "DatasetId": "[DATASET_ID_GUID]",
          "TableName": "[TABLE_NAME]"
        }
      }
    ]
  }
}
